LEGGIMI.txt

===== Informazioni generali =====

Il file può essere consultato comodamente utilizzando LibreOffice Calc / Microsoft Excel / Google Spreadsheet. Il contenuto è leggibile tramite qualunque editor di testo che supporti file grandi.

È possibile reperire una copia di questo dump al seguente URL: https://archive.org/details/dump_release_tntvillage_2019-08-30

===== Changelog =====

1.0 -> primo rilascio del dump
1.1 -> secondo rilascio del dump
       - corretto errore alla riga 6643 del file CSV (valore info_hash errato, rimossi caratteri di quoting spuri)
       - README: aggiunte due nuove sezioni ("Changelog" e "Informazioni campo HASH")
       - rinominato README.txt in LEGGIMI.txt
       - tradotto file LEGGIMI.txt in inglese (README.txt)

===== Informazioni campo HASH =====

Data una voce nel file CSV, tramite il valore incluso nel campo "HASH" è possibile effettuare il download del relativo torrent. A tal proposito si distinguono due casi:
1. il client BitTorrent in uso supporta il download tramite il solo valore contenuto nel campo "HASH"
2. il client BitTorrent in uso supporta necessita di un magnet URI (è possibile ricavarne uno valido a partire dal valore contenuto nel campo "HASH")

Nel primo caso sarà sufficiente copiare il valore contenuto nel campo "HASH", rimuoverne i doppi apici ed incollarlo nel campo link torrent / magnet del proprio client BitTorrent.
Nel secondo caso sarà necessario copiare il valore contenuto nel campo "HASH", rimuoverne i doppi apici, preporre ad esso la seguente stringa: magnet:?xt=urn:btih: ↵
e incollare l'URI generato nel campo link torrent / magnet del proprio client BitTorrent.
Esempio: HASH -> "2DA3E3A01ED438826CBE88DCB3482FE9A1133915"
Risultato primo caso (hash senza apici): 2DA3E3A01ED438826CBE88DCB3482FE9A1133915
Risultato secondo caso (URI magnet): magnet:?xt=urn:btih:2DA3E3A01ED438826CBE88DCB3482FE9A1133915

È inoltre possibile scaricare un archivio contenente tutti i file torrent referenziati in questo dump presso il seguente URL: https://archive.org/details/torrent_release_tntvillage_2019-08-30

Viene effettuato il quoting di tutti i campi non numerici.

README.txt

===== General information =====

The dump in CSV format included in this release contains information about releases published to date (2019-08-30) on TNTVillage. The entries are in descending order by release creation date.
The dump does NOT include the extended textual description of the releases (release body).
The file can be conveniently accessed using LibreOffice Calc / Microsoft Excel / Google Spreadsheet. The content can be read using any text editor that supports large files.

A copy of this dump can be found at the following URL: https://archive.org/details/dump_release_tntvillage_2019-08-30


===== Changelog =====

1.0 -> first release of the dump
1.1 -> second release of the dump
       - fixed error on line 6643 of the CSV file (wrong info_hash value, removed spurious quoting characters)
       - README: added two new sections ("Changelog" and "HASH field information")
       - renamed README.txt to README.txt
       - translated README.txt file into English (README.txt)


===== CSV file field legend =====

DATA: date in ISO 8601 format
HASH: info_hash encoded in hexadecimal
TOPIC: numeric ID related to the discussion (TNTVillage forum)
POST: numeric ID related to the message (TNTVillage forum)
AUTORE: username of the release author
TITOLO: release title
DESCRIZIONE: release metadata
DIMENSIONE: overall size of the release files (in bytes)
CATEGORIA: numeric ID related to the release category


===== Category ID legend =====

1 = TV movies and programs
2 = Music
3 = E Books
4 = Movies
6 = Linux
7 = Anime
8 = Cartons
9 = Macintosh
10 = Windows Softwares
11 = Pc Game
12 = Playstation
13 = Students Releases
14 = Documentaries
21 = Music Videos
22 = Sport
23 = Theatre
24 = Wrestling
25 = Various
26 = Xbox
27 = Wallpaper images
28 = Other Games
29 = TV series
30 = Comics
31 = Trash
32 = Nintendo
34 = A Book
35 = Podcast
36 = Newsstand
37 = Mobile


===== Release URL information (TNTVillage forum) =====

Given an entry in the CSV file, using the numeric ID included in the "TOPIC" field it is possible to obtain the corresponding release URL on the TNTVillage forum.
Example: TOPIC -> 10965, release URL -> http://forum.tntvillage.scambioetico.org/index.php?showtopic=10965
In practice it is sufficient to insert the numeric ID of the "TOPIC" at the end of the base URL.
Base URL: http://forum.tntvillage.scambioetico.org/index.php?showtopic=

Should the TNTVillage forum be inaccessible, it is possible to consult the release pages using the Wayback Machine service offered by the Internet Archive: https://web.archive.org/
Given a URL of a release on the TNTVillage forum it is possible to generate a valid URL for the Wayback Machine by adding the following string at the top of it: https://web.archive.org/web/
Example:
Release URL: http://forum.tntvillage.scambioetico.org/index.php?showtopic=10965
Wayback Machine URL: https://web.archive.org/web/http://forum.tntvillage.scambioetico.org/index.php?showtopic=10965


===== HASH field information =====

Given an entry in the CSV file, using the value included in the "HASH" field it is possible to download the related torrent. In this regard, two cases can be distinguished:
1. the BitTorrent client in use supports the download using just the value contained in the "HASH" field
2. the BitTorrent client in use supports needs a magnet URI (it is possible to obtain a valid one starting from the value contained in the "HASH" field)

In the first case it will be sufficient to copy the value contained in the "HASH" field, remove the double quotes and paste it into the torrent / magnet link field of your BitTorrent client.
In the second case it will be necessary to copy the value contained in the "HASH" field, remove the double quotes, prepend it with the following string: magnet:?xt=urn:btih: ↵
and paste the generated URI into the torrent / magnet link field of your BitTorrent client.
Example: HASH -> "2DA3E3A01ED438826CBE88DCB3482FE9A1133915"
First case result (hash without quotes): 2DA3E3A01ED438826CBE88DCB3482FE9A1133915
Second case result (URI magnet): magnet:?xt=urn:btih:2DA3E3A01ED438826CBE88DCB3482FE9A1133915

You can also download an archive containing all the torrent files referenced in this dump at the following URL: https://archive.org/details/torrent_release_tntvillage_2019-08-30


===== Technical information about the CSV file =====

The CSV file uses the comma character (,) as a separator.
The line termination character is the standard UNIX one (\n).
The quoting character is: ".
The escaping character is: ".
All non-numeric fields are quoted.